﻿CREATE TABLE [dbo].[CiFile] (
    [Id]           NVARCHAR (40)  CONSTRAINT [DF_CiFile_Id] DEFAULT (('{'+CONVERT([char](36),newid(),(0)))+'}') NOT NULL,
    [FolderId]     NVARCHAR (40)  NULL,
    [FileName]     NVARCHAR (200) NOT NULL,
    [FilePath]     NVARCHAR (500) NULL,
    [FileContent]  IMAGE          NULL,
    [FileSize]     NUMERIC (18)   NULL,
    [ImageUrl]     NVARCHAR (200) NOT NULL,
    [ReadCount]    INT            CONSTRAINT [DF__CiFile__ReadCoun__07020F21] DEFAULT ((0)) NOT NULL,
    [Category]     NVARCHAR (50)  NULL,
    [Description]  NVARCHAR (800) NULL,
    [Enabled]      INT            CONSTRAINT [DF__CiFile__Enabled__07F6335A] DEFAULT ((1)) NOT NULL,
    [SortCode]     INT            NULL,
    [DeleteMark]   INT            CONSTRAINT [DF_CiFile_DeleteMark] DEFAULT ((0)) NOT NULL,
    [CreateOn]     DATETIME       CONSTRAINT [DF__CiFile__CreateOn__08EA5793] DEFAULT (getdate()) NOT NULL,
    [CreateUserId] NVARCHAR (50)  NULL,
    [CreateBy]     NVARCHAR (50)  NULL,
    [ModifiedOn]   DATETIME       NULL,
    [ModifyUserId] NVARCHAR (50)  NULL,
    [ModifiedBy]   NVARCHAR (50)  NULL,
    CONSTRAINT [PK_CIFILE] PRIMARY KEY NONCLUSTERED ([Id] ASC)
);

